Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_XML_TAB_COLS

`ALL_XML_TAB_COLS` describes the columns of the XML tables accessible to the current user.

Related Views

- `DBA_XML_TAB_COLS` describes the columns of all XML tables in the database.

- `USER_XML_TAB_COLS` describes the columns of the XML tables owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` |  | Owner of the XML table
`TABLE_NAME` | `VARCHAR2(30)` |  | Name of the XML table
`COLUMN_NAME` | `VARCHAR2(4000)` |  | Name of the XML table column
`XMLSCHEMA` | `VARCHAR2(700)` |  | Name of the XML Schema that is used for the table definition
`SCHEMA_OWNER` | `VARCHAR2(30)` |  | Owner of the XML Schema that is used for the table definition
`ELEMENT_NAME` | `VARCHAR2(256)` |  | Name of the XML SChema element that is used for the table
`STORAGE_TYPE` | `VARCHAR2(17)` |  | Storage option for the XMLtype data (`OBJECT-RELATIONAL` or `CLOB`)

See Also: "DBA_XML_TAB_COLS" "USER_XML_TAB_COLS"